package com.ghck.shop.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.ghck.shop.model.MakerRank;

public interface MakerRankMapper {

	
	@Select("select t1.maker_user_id makerUserId,sum(amount) percentage,sum(total_payee)tradingVolumes,count(distinct t2.user_id)customerCount "
			+ "from t_maker_flow_water t1,order_info t2 where t1.order_id=t2.id group by t1.maker_user_id order by percentage desc ")
	public List<MakerRank> makerRankList(String type);
}
